/********************************************************************************/
/** dmb This was done so ratings can be standardized                          **/
/******************************************************************************/

/**also drop old table not needed UserTest**/

Use Image
GO

DROP TABLE [dbo].[UserTest];
GO

DROP TABLE [dbo].[Rating];
GO

-- Creating table 'Rating' to hold rating params
CREATE TABLE [dbo].[Rating] (
    [ratingid] int  NOT NULL,
	[description] varchar(80) NULL
);
GO


insert into rating values (1,'lowest rating out of 1 thru 5');
insert into rating values (2,'2nd place rating');
insert into rating values (3,'3d place rating');
insert into rating values (4,'4th place rating');
insert into rating values (5,'highest, most favorable rating, 5');
